from typing import TYPE_CHECKING

from sqlalchemy import Boolean, Column, Integer, String, text, TIMESTAMP, BigInteger, Numeric, FetchedValue, DateTime

from app.db.base_class import Base


class PickerStrategy(Base):
    __tablename__ = 'tb_picker_strategy'

    id = Column(BigInteger, primary_key=True)
    pickerId = Column('picker_id',BigInteger, nullable=False)
    strategyId = Column('strategy_id',BigInteger, nullable=False, info='策略id')
    strategyCodeId = Column('strategy_code_id',BigInteger)
    conditions = Column(String(512), nullable=False)
    createdDate = Column('created_date', TIMESTAMP, server_default=text('CURRENT_TIMESTAMP'))


